﻿<%@ page language="C#" autoeventwireup="true" inherits="_edu_teacher_J1_QueryPerformance, App_Web_j1_queryperformance.aspx.360d3660" %>

<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
    
    <script language="javascript" src="../../window/jquery/jquery.min.js" type="text/javascript"></script>
    <script language="javascript" src="../../window/jquery-ui/jquery-ui.min.js" type="text/javascript"></script>
    <script language="javascript" src="../../window/message/jquery.message.js" type="text/javascript"></script>
    <script language="javascript" src="../../window/checked/jquery.checked.js" type="text/javascript"></script>
    <script language="javascript" src="../../window/maxInput/jquery.maxInput.js" type="text/javascript"></script>
    <script language="javascript" src="../../window/My97DatePicker/WdatePicker.js" type="text/javascript"></script>
    <script language="javascript" src="../../window/TableRowFocus/jquery.RowFocus.js" type="text/javascript"></script>

    <link href="../../window/_css/jquery-ui.custom.css" rel="stylesheet" type="text/css" />
    <link href="../../window/_css/window.css" rel="stylesheet" type="text/css" />
    <link href="../../css/listpage.css" rel="stylesheet" type="text/css" />
    <title>学校教师业绩列表</title>

    <script language="javascript" type="text/javascript">

    $(function(){
        cascade($("#ddlSchool"),$("#ddlTeacher"));
        if($("#hfteacherID").val()!=""){
            $("#ddlTeacher").html("<option value="+$("#hfteacherID").val()+">"+$("#hfteacherName").val()+"</option>");
            $("#ddlSchool").val('');
        }
        $("#btnQuery").click(function(){
           var ddlteacher = $("#ddlTeacher");
           $("#hfteacherID").val(ddlteacher.val());
           $("#hfteacherName").val(ddlteacher.children(":selected").text())
           
           var snumber = $.trim($("#txtSNumber").val());
           var avg = $.trim($("#txtavg").val());
           var pass = $.trim($("#txtpass").val());
           var er = $.trim($("#txter").val())
           if(snumber!=""){
                if(!snumber.match(/^[0-9]+?$/)){
                     message("错误 学生数 只能输入整数！",1);
                     return false;
                }
           }
           else if(avg!="" ){
                if(!avg.match(/^[0-9]+(.[0-9]{1,2})?$/)){
                     message("错误 平均分 只能输入数值！",1);
                     return false;
                }
           }else if(pass!=""){
                if(!pass.match(/^[0-9]+(.[0-9]{1,2})?$/)){
                     message("错误 合格率 只能输入数值！",1);
                     return false;
                }
           }else if(er!=""){
                if(!er.match(/^[0-9]+(.[0-9]{1,2})?$/)){
                    message("错误 优秀率 只能输入数值！",1);
                    return false;
                }
           }
           
              
        });
       
    });
  
    function cascade(parent,target){
         //入学年份联动 班级
         parent.change(function(){
             if(this.value=="")return null;
             $.ajax({
                   type: "POST",
                   dataType:"json",
                   url:"J1_QueryPerformance.aspx",
                   data: {cascadeSchool:this.value},
                   success: function(data){
                        if(data.state==1){
                            target.html(data.value);
                        }else{
                            message(data.value,1);
                        }
                   },
                   beforeSend:function(){
                        target.html("<option >加载中...</option>");
                        return true;
                   },
                   error: function() {target.html("<option >加载失败...</option>"); return false; } 
             });
         });
   }
  


    </script>

    <style type="text/css">
<!--
.center {
	text-align: center;
}
-->
</style>
</head>
<body>
    <form id="form2" runat="server">

       <div class="ui-widget-header " style="padding: .4em 1em; margin:2px">
            <span class="ui-dialog-title" > 教师业绩查询</span>
         
        </div>
        <div class="panel"  style="width:99%;overflow:auto"   >
            <table>
                <tr>
                    <td style="width: 113px">
                        任教学校</td>
                    <td style="width: 123px">
                        教师姓名</td>
                    <td style="width: 102px">
                        学期</td>
                    <td style="width: 110px">
                        年度</td>
                    <td style="width: 97px">
                        学校分类</td>
                    <td style="width: 99px">
                        年级</td>
                    <td style="width: 177px">
                        考试类别</td>
                    <td style="width: 108px">
                        </td>
                </tr>
                <tr>
                    <td style="width: 113px">
                       <asp:DropDownList ID="ddlSchool" runat="server" Width="100px">
                        </asp:DropDownList>
                        </td>
                    <td style="width: 123px">
                        <select id="ddlTeacher" style="width: 114px" >
                            
                        </select>
                    </td>
                    <td style="width: 102px">
                        <asp:DropDownList ID="ddlTerm" runat="server" Width="100px">
                        </asp:DropDownList>
                    </td>
                    <td style="width: 110px">
                        <asp:DropDownList ID="ddlSchoolYear" runat="server" Width="115px">
                        </asp:DropDownList>
                    </td>
                    <td style="width: 97px">
                        <asp:DropDownList ID="ddlSchoolClassify" runat="server" Width="94px">
                        </asp:DropDownList>
                    </td>
                    <td style="width: 99px">
                        <asp:DropDownList ID="ddlGrade" runat="server" Width="94px">
                        </asp:DropDownList>
                    </td>
                    <td style="width: 177px">
                        <asp:DropDownList ID="ddlExamType" runat="server" Width="98px">
                        </asp:DropDownList>
                    </td>
                    <td style="width: 108px">
                        </td>
                </tr>
                <tr>
                    <td style="width: 113px">
                        班级</td>
                    <td style="width: 123px">
                        学生数</td>
                    <td style="width: 102px">
                        任教学科</td>
                    <td style="width: 110px">
                        平均分</td>
                    <td style="width: 97px">
                        及格率</td>
                    <td style="width: 99px">
                        优生率</td>
                    <td style="width: 177px">
                        提交日期</td>
                    <td style="width: 108px">
                        提交用户</td>
                </tr>
                <tr>
                    <td style="width: 113px">
                        <asp:TextBox ID="txtClass" runat="server" Width="94px"></asp:TextBox></td>
                    <td style="width: 123px">
                        <asp:DropDownList ID="ddlSNumberExp" runat="server" Width="37px">
                            <asp:ListItem>=</asp:ListItem>
                            <asp:ListItem>&lt;</asp:ListItem>
                            <asp:ListItem>&gt;</asp:ListItem>
                        </asp:DropDownList>
                        <asp:TextBox ID="txtSNumber" runat="server" Width="69px"></asp:TextBox></td>
                    <td style="width: 102px">
                        <asp:DropDownList ID="ddlSubject" runat="server">
                        </asp:DropDownList></td>
                    <td style="width: 110px">
                        <asp:DropDownList ID="ddlavgExp" runat="server" Width="37px">
                            <asp:ListItem>=</asp:ListItem>
                            <asp:ListItem>&lt;</asp:ListItem>
                            <asp:ListItem>&gt;</asp:ListItem>
                        </asp:DropDownList><asp:TextBox ID="txtavg" runat="server" Width="66px"></asp:TextBox></td>
                    <td style="width: 97px"><asp:DropDownList ID="ddlpassExp" runat="server" Width="37px">
                        <asp:ListItem>=</asp:ListItem>
                        <asp:ListItem>&lt;</asp:ListItem>
                        <asp:ListItem>&gt;</asp:ListItem>
                    </asp:DropDownList><asp:TextBox ID="txtpass" runat="server" Width="53px"></asp:TextBox></td>
                    <td style="width: 99px"><asp:DropDownList ID="ddlerExp" runat="server" Width="37px">
                        <asp:ListItem>=</asp:ListItem>
                        <asp:ListItem>&lt;</asp:ListItem>
                        <asp:ListItem>&gt;</asp:ListItem>
                    </asp:DropDownList><asp:TextBox ID="txter" runat="server" Width="53px"></asp:TextBox></td>
                    <td style="width: 177px"><asp:DropDownList ID="ddlDateExp" runat="server" Width="37px">
                        <asp:ListItem>=</asp:ListItem>
                        <asp:ListItem>&lt;</asp:ListItem>
                        <asp:ListItem>&gt;</asp:ListItem>
                    </asp:DropDownList>
                    <asp:TextBox ID="txtDateTime" runat="server" Width="127px" onFocus="WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss',disabledDates:['%y-%M-%d {%H-1}\:..\:..','%y-%M-%d {%H+1}\:..\:..']})" ></asp:TextBox>
                    </td>
                    <td style="width: 108px">
                        <asp:TextBox ID="txtSubmitUser" runat="server" Width="103px"></asp:TextBox></td>
                </tr>
                <tr>
                    <td style="width: 113px">
                        教师姓名(模糊查询)</td>
                    <td style="width: 123px">
                        教师身份证(模糊查询)</td>
                    <td style="width: 102px">
                    </td>
                    <td style="width: 110px">
                    </td>
                    <td style="width: 97px">
                    </td>
                    <td style="width: 99px">
                    </td>
                    <td style="width: 177px">
                        </td>
                    <td style="width: 108px">
                        &nbsp;</td>
                </tr>
                <tr>
                    <td style="width: 113px">
                        <asp:TextBox ID="txtLTName" runat="server" Width="106px"></asp:TextBox></td>
                    <td style="width: 123px">
                        <asp:TextBox ID="txtLTIDNumber" runat="server" Width="106px"></asp:TextBox></td>
                    <td style="width: 102px">
                    </td>
                    <td style="width: 110px">
                    </td>
                    <td style="width: 97px">
                    </td>
                    <td style="width: 99px">
                        <asp:Button ID="btnShowAll" runat="server" CssClass="btn" OnClick="btnClear_Click"
                            Text="取消查询" /></td>
                    <td style="width: 177px">
                    <asp:Button id="btnExcal"  runat="server" Text="导出EXCAL" CssClass="btn" ToolTip="查询信息导出EXCAL" OnClick="btnExcal_Click"></asp:Button>
                        </td>
                    <td style="width: 108px">
                        <asp:Button ID="btnQuery" runat="server" CssClass="search" Text="查询" OnClick="btnQuery_Click" /></td>
                </tr>
            </table>
            </div>
           
        <asp:GridView ID="ViewData" runat="server" AutoGenerateColumns="False" BackColor="White"
            CssClass="gv" Width="100%">
            <RowStyle CssClass="gvRow" />
            <HeaderStyle CssClass="gvHeader" />
            <AlternatingRowStyle CssClass="gvAlternatingRow" />
            <EmptyDataRowStyle CssClass="gvEmpty" />
            <Columns>
                <asp:BoundField DataField="tb_name" HeaderText="教师名称" />
                <asp:BoundField DataField="tb_idNumber" HeaderText="身份证号码" />
                
                <asp:BoundField DataField="sy_name" HeaderText="年度" />
                <asp:BoundField DataField="tm_name" HeaderText="学期" />
                <asp:BoundField DataField="sl_name" HeaderText="任教学校" />
                <asp:BoundField DataField="sc_name" HeaderText="学校分类" />
                <asp:BoundField DataField="ge_name" HeaderText="年级" />
                <asp:BoundField DataField="tp_class" HeaderText="班级" />
                <asp:BoundField DataField="tp_studNumber" HeaderText="学生数" />
                <asp:BoundField DataField="st_name" HeaderText="任教学科" />
                <asp:BoundField DataField="tp_avg" HeaderText="平均分" />
                <asp:BoundField DataField="tp_pass" HeaderText="及格率" />
                <asp:BoundField DataField="tp_er" HeaderText="优生率" />
                <asp:BoundField DataField="et_name" HeaderText="考试类别" />
                <asp:BoundField DataField="tp_idate" HeaderText="提交日期" />
                <asp:BoundField DataField="tp_user" HeaderText="提交用户" />

                
            </Columns>
            <EmptyDataTemplate>
                没有任何数据！
            </EmptyDataTemplate>
            
        </asp:GridView>
        <br />
        <webdiyer:AspNetPager ID="PagerButtom" runat="server" AlwaysShow="True" CssClass="paginator"
            CustomInfoHTML="当前第%CurrentPageIndex%/%PageCount%页 共%RecordCount%条记录 每页%PageSize%条 "
            CustomInfoSectionWidth="" FirstPageText="首页" HorizontalAlign="Right" LastPageText="尾页"
            LayoutType="Table" MoreButtonsClass="" NextPageText="下一页" NumericButtonCount="5"
            OnPageChanged="Pager_PageChanged" PageIndexBoxClass="cpb" PrevPageText="上一页"
            ShowCustomInfoSection="Right" ShowPageIndexBox="Always" SubmitButtonText="转到">
        </webdiyer:AspNetPager>
        <div id="insertPanel" style="display: none;">
            <asp:HiddenField ID="hfteacherID"  runat="server" />
            <asp:HiddenField ID="hfteacherName"  runat="server" />
        </div>
    </form>
</body>
</html>
<!--powered by 25175-->
